.NET Courses
UI Technologies
Cloud Computing
Data Engineering
AI / ML
Microsoft Power Platform
Testing Tools
Others
  1. Constraints
Interview Questions and Answer
Options:
a. NOT NULL
b. CHECK
c. NULL
d. UNIQUE
Reveal Answer
Options:
a. Column
b. Table
c. Field
d. All of the mentioned
Reveal Answer
Options:
a. 4
b. 5
c. 6
d. 7
Reveal Answer
Options:
a. Unique can have multiple NULL values but Primary can’t have.
b. Unique can have single NULL value but Primary can’t have even single.
c. Both can have duplicate values
d. None of the Mentioned
Reveal Answer
Options:
a. Foreign Key
b. Unique Key
c. Primary Key
d. None of the Mentioned
Reveal Answer
Options:
a. CHECK constraints enforce domain integrity
b. UNIQUE constraints enforce the uniqueness of the values in a set of columns
c. In a UNIQUE constraint, no two rows in the table can have the same value for the columns
d. All of the mentioned
Reveal Answer
Options:
a. ALTER TABLE<Table Name> ADD CONSTRAINT<Constraint name> Constraint (column name)
b. ADD TABLE<Table Name> ADD CONSTRAINT<Constraint name> Constaint (column name)
c. ALTER TABLE<Table Name> ADD CONSTRAINT<Constraint name>
d. All the above
Reveal Answer
Options:
a. Primary Key
b. Default
c. Check
d. Foreign Key
Reveal Answer
Options:
a. Create table employees (eid int, Fname varchar 20 notnull)
b. Create table employees (eid int, Fname varchar 20 not null)
c. Create table employees (eid int, Fname varchar 20 foreign key)
d. All the above
Reveal Answer
Options:
a. yes
b. No
Reveal Answer
Options:
a. A primary key applied on more than one column
b. When a table contains more than one primary key
c. All the above
d. Non of these
Reveal Answer
Options:
a. Unique constraint will not allow duplicate values into the columns on which it is defined
b. Unique constraints makes table rows unique
c. Unique constraint will not allow redundant rows
d. All the above
Reveal Answer
Options:
a. Create table Employees (eid int, Ename varchar(10) Age int exp int check(exp<10) )
b. Create table Employees (eid int, Ename varchar(10) Age int constraint chk_age_ int check(age>exp) )
c. Create table Employees ( eid int, Ename varchar(10) Age int Constraint check(age>exp) )
d. All the above
Reveal Answer
Options:
a. 1
b. 3
c. 4
d. 2
Reveal Answer
Options:
a. constraints are used for restricting data coming into tables
b. constraints are used for enforcing business rules
c. constraints used for validating data
d. All the above
Reveal Answer
Packages
Trending Certification Courses:
Microsoft Mock Exams:
Other links
About
Resources
Bestdotnet google plus
© Copyright 1997 - 2024 | www.bestdotnettraining.com | www.deccansoft.com | All Rights Reserved.